UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qCEIy6Kp16uDjkzWzvoTzy3A3uQareBK7t1QhvSNluA='
WHERE
key_id = '9747851e9a364617a6c091b182ac5cde96aa8efafca52e80f5e69542ca7f0a1a'
AND (
token = 'qCEIy6Kp16uDjkzWzvoTzy3A3uQareBK7t1QhvSNluA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)