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