UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'XBpJ8wywE535AhK0wGyrtmj69Xw2hAC4xR5lvGMhNBY=' 
WHERE 
  key_id = '43ea6de021593c1143e7780a87cdd47c4d178bb5f4a39297a11ad9f0a4689df6' 
  AND (
    token = 'XBpJ8wywE535AhK0wGyrtmj69Xw2hAC4xR5lvGMhNBY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027