UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'O6dOmLJev5wcLKxfE4QGJm5VSWL0+iLRDVkh2o0Y6SE=' 
WHERE 
  key_id = '9c4fa555bcd0fe72869b7a8ad7093c4e4cb4306a9733d6f8fba4f2d05126154a' 
  AND (
    token = 'O6dOmLJev5wcLKxfE4QGJm5VSWL0+iLRDVkh2o0Y6SE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021