UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '3PPkvA6GMmfFL8cDXZ8lzd3xZwI+6apLSxtwKdkvvU0=' 
WHERE 
  key_id = '661b3c09b5c8218cc5dd3dd3fa7db65327e6585543b1b38d22604a2600b46a95' 
  AND (
    token = '3PPkvA6GMmfFL8cDXZ8lzd3xZwI+6apLSxtwKdkvvU0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022