UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'w9HUvw3wscsaIlHv5WkDew08LKi5Xl6YzLNK10+ROJc=' 
WHERE 
  key_id = '9e383c29e6dd5d9c3489f8926502a9b2e7e7b443a5bfeab9680b0bc330f31ac4' 
  AND (
    token = 'w9HUvw3wscsaIlHv5WkDew08LKi5Xl6YzLNK10+ROJc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031