UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W2HcAE+l6UdvQ7oLLdo7E0pkPqnkTt9QPmg8CFyWobo='
WHERE
key_id = 'e65c5a1e86e04e5e46655d45554a0252ec897173f8dfaf7a6b8218c9514adb8e'
AND (
token = 'W2HcAE+l6UdvQ7oLLdo7E0pkPqnkTt9QPmg8CFyWobo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)