UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'IyU146dkcF3myUR2/sCeiRnJW9QS9O+Xd/aCEKHWspU=' 
WHERE 
  key_id = '917d9affd270b2080d45a7c9a65266972031600f101ae88edb830b13666d219a' 
  AND (
    token = 'IyU146dkcF3myUR2/sCeiRnJW9QS9O+Xd/aCEKHWspU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026