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