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