UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6TG5ZKe06FgnChVhoEqutcv3D7QAVkR8Qw8Lqzx+MT0='
WHERE
key_id = 'def07f8a67094ea20a331dabc5a51594ed1d10c5a264b2008cc521af6ee672d4'
AND (
token = '6TG5ZKe06FgnChVhoEqutcv3D7QAVkR8Qw8Lqzx+MT0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)