UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3T0P9oyOt4MNCccmkJV7gciH/nYiiH4D/cAEYnczrcU='
WHERE
key_id = 'e60b330f474949bd9a972b19c99571f2c2e74385e695feddeec317913752ade0'
AND (
token = '3T0P9oyOt4MNCccmkJV7gciH/nYiiH4D/cAEYnczrcU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)