UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '7PbUiAoa5VyOv66A+pE1BXdDQj+sKVVZW7MWlfFVtiQ=' 
WHERE 
  key_id = 'b6d346ddebfd3c9cc5b2c7b939fe62ec00cf53c1c6a737eae94f2b1e4a5f965e' 
  AND (
    token = '7PbUiAoa5VyOv66A+pE1BXdDQj+sKVVZW7MWlfFVtiQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028