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