UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qiJ5MSswhqWpGT3JQnfMCEegmOCywMhZs7K0xobweKc='
WHERE
key_id = 'a07b0a988d688105d04af5e0e3655bc898fbb9f89b878390baee58e4382e0d20'
AND (
token = 'qiJ5MSswhqWpGT3JQnfMCEegmOCywMhZs7K0xobweKc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)