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