UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8QFx1VIj3faq0sC1yYr0X3CcstJlXGZrl1/UlGUkdaQ='
WHERE
key_id = '582a5c694bd8c82d4842702bb848f37563f400beaddb6b70741de63cc80bdd8e'
AND (
token = '8QFx1VIj3faq0sC1yYr0X3CcstJlXGZrl1/UlGUkdaQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)