UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '248fENd44mtr96qyewHh3JDf4TpycDVPnSzPz/8NFTw=' 
WHERE 
  key_id = '842e5440cdca7bcb88e82e57b3b0e166da24e7610b39824facb6b9b1b0faa0c4' 
  AND (
    token = '248fENd44mtr96qyewHh3JDf4TpycDVPnSzPz/8NFTw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029