UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zN4HUxC11ErJYoQBxMJ8rKTCEs2c3iikI1gi3AgVawU='
WHERE
key_id = '7cc944e46f760d5724e046c2d55e3a245e348255b1876bab8e645e3faedc72d7'
AND (
token = 'zN4HUxC11ErJYoQBxMJ8rKTCEs2c3iikI1gi3AgVawU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)