UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2zHld+a2Qn/lpF+nABRHxkIeDKaNHJJ0CnHsXoOusys=' 
WHERE 
  key_id = '057b3f06b0563590b6d57c27bc8b9d8459d1c416840e045a9aa7c2ce9e907fdc' 
  AND (
    token = '2zHld+a2Qn/lpF+nABRHxkIeDKaNHJJ0CnHsXoOusys=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027