UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'pKTDf985BE1EIkhDKS4hRSQj4VTAeCTpfUZ6Umi8ACY=' 
WHERE 
  key_id = '38298d3db7a4044c70ee4abeca223b0c6c042896e4a7e3fa9e9a7923c25ffb4d' 
  AND (
    token = 'pKTDf985BE1EIkhDKS4hRSQj4VTAeCTpfUZ6Umi8ACY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00186