UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kYrWmymyAIHVQSOp+AhASFYl8QVZRQOm+dPl4J99kvg='
WHERE
key_id = 'd6c289fd8b348bf58d34eff5042709aaf66bae2fa9cf81b24cac35887b2af463'
AND (
token = 'kYrWmymyAIHVQSOp+AhASFYl8QVZRQOm+dPl4J99kvg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)