UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'TNrS3m7+s6uDKbY/ONRd8WWG8QvCvBvEp5Umiv+Yp8Y=' 
WHERE 
  key_id = '92235ae4ce93cb52deccef0ed2fe6e3cc914e1926764c1f50cb1360c5c5101a4' 
  AND (
    token = 'TNrS3m7+s6uDKbY/ONRd8WWG8QvCvBvEp5Umiv+Yp8Y=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024