UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'blksJ2jBP4kyA6Yjxwja/3RDKwNqKy0CI1iVcox3cRs='
WHERE
key_id = 'faedef85e29ea1786789c5a1039676bf7387b93df6a2fc60710f6866e4f01f8a'
AND (
token = 'blksJ2jBP4kyA6Yjxwja/3RDKwNqKy0CI1iVcox3cRs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)