UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+j5gA+raGigXGzTkgG6CRmzOoudPzXSA0zafIWhHwrE=' 
WHERE 
  key_id = '6bc589a8cc5a939c6ca31fb621e0123007d64a3fa600165d493ada5c1cb26799' 
  AND (
    token = '+j5gA+raGigXGzTkgG6CRmzOoudPzXSA0zafIWhHwrE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023