UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PzbCCeYO+6ucansM2NlbgkpVSVqvsCw2gBGg9oA36xY='
WHERE
key_id = '9b9a2ccb2d2ef673852fac98d8cab7c2654bd27ff733ec0280eb312f7e68e5a9'
AND (
token = 'PzbCCeYO+6ucansM2NlbgkpVSVqvsCw2gBGg9oA36xY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)