UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xhU30FJGfT0fK6b5WOgdujQpijP0dfeX+mOR0k4+Bs0='
WHERE
key_id = 'c9cf7d248cfe73e988a8dcfb7a1410d1bb1b50503857771df96a400556404aef'
AND (
token = 'xhU30FJGfT0fK6b5WOgdujQpijP0dfeX+mOR0k4+Bs0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)