UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SmkVF2Io8lqCQ6k9W+DC0Wgiknj6AejlHmh5Io39/0w='
WHERE
key_id = 'b74d1f304f2e31b40eda946c796fb74fedfbd55fe49a40d4898836aabf129ae5'
AND (
token = 'SmkVF2Io8lqCQ6k9W+DC0Wgiknj6AejlHmh5Io39/0w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)