UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uIVO8b7gGWdx9YaVCim9j3RzhccD4UyHJG/64ENUHsU='
WHERE
key_id = 'bc04ec0c78e978df4946894f6bc56401c8b7f2e93e682fa9b75988de87d51e12'
AND (
token = 'uIVO8b7gGWdx9YaVCim9j3RzhccD4UyHJG/64ENUHsU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)