UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LBY78Kl2LB9W67RuJAwmm6SHGctBKz/jHouziOHzw58='
WHERE
key_id = 'ad8a5aed29409df5403a6e94ba25db6701c8f459db3c3716ca3d7851fed44742'
AND (
token = 'LBY78Kl2LB9W67RuJAwmm6SHGctBKz/jHouziOHzw58='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)