UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'dtk0W1PKrUgs0+CCaTS0SaDhQ9+lgMRH4x+1IRsjH9k=' 
WHERE 
  key_id = '8839b0b1ab39f46628d9d507bcb7e4c44bfb304c2a2b02b904b25777f9f9e318' 
  AND (
    token = 'dtk0W1PKrUgs0+CCaTS0SaDhQ9+lgMRH4x+1IRsjH9k=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025