UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'MHfX3GCxZOH1Ue12KiB+DW6krq/MXeg4YHqqTDgXxzE=' 
WHERE 
  key_id = '3e7a8eb06792f35df17fb959adc53e52b12f00aaff00eeb812e2d632be33a5ff' 
  AND (
    token = 'MHfX3GCxZOH1Ue12KiB+DW6krq/MXeg4YHqqTDgXxzE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024