UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aXxUeoEinM1WVJzsTAKLAmvh4dYvcwAwo0gsoho0/dU='
WHERE
key_id = 'b9723344a6a2442d897809f76811adb24884de93b90d417e1ac7e56689c5929b'
AND (
token = 'aXxUeoEinM1WVJzsTAKLAmvh4dYvcwAwo0gsoho0/dU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)